removed distribution channel becuase its same as market segment and agent and company have so large number of missing values

cancelation of city hotel are more from every coutry tourist than resort hotel so we can conclude that confirmed booking and check in percentage is more for resort hotel

NLD has lesser percentage of cancelations of resort hotel so chances of NLD booking confirmed for resort hotel is more

and DEU has lesser percentage of cancelations of city hotel so chances of DEU booking confirmed for city hotel is more

as we can see groups cancels more than other market segments

no cancelation of resort hotel from aviation

lowest cancelataion of city hotel from complementary marget segment(only case where cancelation of city hotel is lesser than resort hotel)

lesser number of cancelations are from direct

so chances of direct market segment booking confirmed is more

we can conclude that repeated guest do less cancelations excluding the groups

corporate repeated guest from NLD for resort hotel have maximum chances for confirm check in

onlineTA prefer to be a repeated guest more

refundable and non refundable group cancelations are negligible

but non refund deposit type excluding groups are so high

boxplot to check outliner

outliners removed taking 0.35 percentile as lower z score and 99.65 as higher z score

we can conclude that adr is on peak in august month ie busiest month

lead time has most impact on cancelations as lead time increasing chances of cancelation increase

and in case of special requests the more of special request the lesser are chances of cancelation

city hotel is most booked and canceled but rate of cancelation is less in resort hotel that means those who book resort hotel are maximum sure that they dont need to cancel

as a conclusion on analysing everything that most of the guests prefer to visit in summer as we can see (mostly busiest months are may july august)

atleast one parking space required for every guest

maintain the rooms according to family with babies or childrens(mostly visited by 2 guest with no babies or childrens) so to increase room space maybe helpful

repeated guests are more maybe on asking them what make them to visit here again and again can helpful

adr 65 having good results cant consider 0 because its free

mostly guest stayed for upto 2 nights prefering BB that means morning arrival are more

most guest prefer no deposit that means pay on arrival

as we can see from heatmap that repeated guest and previous booking not cancelled is correlated as the number of adult and childrens increase with guest adr increase and most of the special request are of car parking space